🕷️️ Job Radar • SCRAPING

peopleperhour.com 🟡 2026-05-03

🔹 Automate Data Matching Between Real Estate Dataset and PDF Files in Google Drive
👤 Client: 🇩🇿 Algeria Member since ****
💰 Price: $45/hr
🚩 Problem: Manual linking process between real estate dataset entries and corresponding PDF files is inefficient and error-prone.
📦 Existing: Google Sheets, Google Drive, existing real estate dataset (5,000+ entries), structured PDF filenames based on property lot numbers.

Specifications:

[Target] Generate a mapping table linking lot numbers to Google Drive file URLs
[Method] Use Google Apps Script for automation
[UI/UX] Not specified
[Stack] Google Sheets, Google Drive, Google Apps Script
[Security] Ensure data privacy and security in script execution
[Format] JSON or CSV format for mapping table

Workflow:

1. Access the Google Drive folder containing PDF files.
2. Extract file names and corresponding URLs.
3. Generate a structured mapping table (Lot number → Google Drive link).
4. Integrate this mapping with an existing Google Sheets dataset.
5. Implement a solution to automatically match dataset lot numbers with PDF file links.
6. Ensure the solution is scalable and reusable for future datasets.